package com.dao.purchase;

import com.model.purchase.SupplyCompeteMmModel;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;
import org.apache.ibatis.annotations.Param;

public interface SupplyCompeteMmDao {

	/**
	 * 新增
	 * 
	 * @author chenjun
	 * @date 2022/03/10
	 **/
	int insert(SupplyCompeteMmModel supplyCompeteMmModel);

	int deleteByInfId(String infId);

	List<SupplyCompeteMmModel> selectByInfId(String infId);

	int deleteByInqId(String inqId);

	List<SupplyCompeteMmModel> selectByInqId(String inqId);

	int deleteByPlanId(String planId);

	List<SupplyCompeteMmModel> selectByPlanId(String planId);

	/**
	 * 刪除
	 * 
	 * @author chenjun
	 * @date 2022/03/10
	 **/
	int delete(@Param("infId") String infId, @Param("inqId") String inqId, @Param("planId") String planId);

	/**
	 * 更新
	 * 
	 * @author chenjun
	 * @date 2022/03/10
	 **/
	int update(SupplyCompeteMmModel supplyCompeteMmModel);

	/**
	 * 查询 根据主键 id 查询
	 * 
	 * @author chenjun
	 * @date 2022/03/10
	 **/
	SupplyCompeteMmModel load(@Param("infId") String infId, @Param("inqId") String inqId,
			@Param("planId") String planId);

	// 列表
	List<SupplyCompeteMmModel> selectList(Map<String, Object> map);

	// 列表总数
	int selectListCount(Map<String, Object> map);
}